Using Indices - Mailing list pgsql-general

From Alexander Lohse
Subject Using Indices
Date
Msg-id p05010400b6ecfaec0a5d@[192.168.0.44]
Whole thread Raw
Responses Re: Using Indices
List pgsql-general
Hi,

when I use phpPgAdmin to create DBs, my Indices are getting automatic
names like : pers_UID_key

I am getting confused about the name!

Does that mean a need to do call this in a select query?

"select * from pers where pers_UID_key = '...'"

or do i call the original field?

"select * from pers where UID= '...'"

Thanx,

Alex
--
___________________________
Alexander Lohse
Human Touch Medienproduktion GmbH
Am See 1
17440 Klein Jasedow

Tel: (038374) 75211
Fax: (038374) 75223
eMail: al@humantouch.de
http://www.humantouch.de

pgsql-general by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: 7.0.X-> 7.1 dump/restore required?
Next
From: Daniel ?erud
Date:
Subject: Dissapearing indexes, what's that all about?